Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) Character String Functions
4) Collections
5) Conversion Functions
6) Cursor
7) Date Timestamp Functions
8) Function Procedure Packages
9) Index
10) Insert Update Delete
11) Introduction
12) Large Objects
13) Linear Regression Functions
14) Miscellaneous Functions
15) Numerical Math Functions
16) Object Oriented
17) PL SQL Data Types
18) PL SQL Operators
19) PL SQL Programming
20) PL SQL Statements
21) Query Select
22) Regular Expressions Functions
23) Sequences
24) Set
25) SQL Data Types
26) SQL PLUS Session Environment
27) Statistical Functions
28) System Packages
29) System Tables Data Dictionary
30) Table
31) Table Joins
32) Transaction
33) Trigger
34) User Privilege
35) View
36) XML

View
1) A user-defined type view
2) Alter MATERIALIZED VIEW dept20_mv enable query rewrite
3) Because employee_view didnt use WITH CHECK OPTION, you can insert, update, and delete rows that arent retrievable by the subquery
4) Choose specific column from base table
5) Create a complex view with group by and having clause
6) Create a view by joining two tables
7) Create a view for employee and its course during
8) Create a view to link two table together
9) Create a view with condition
10) CREATE MATERIALIZED VIEW with rowid
11) CREATE MATERIALIZED VIEW with TABLESPACE
12) Create materialized view
13) Create materialized view emp_dept build immediate refresh on demand enable query rewrite
14) Create view based on aggregate function
15) Create view based on user-defined function
16) Create view by join three tables
17) Create view on single field of a type
18) Creating a simple filtering view
19) Creating a view that joins tables
20) Creating a View with a CHECK OPTION Constraint
21) Creating a View with a READ ONLY Constraint
22) Creating and Using a View
23) Creating and Using Simple Views
24) Drop materialized view
25) Dropping a View
26) Getting Information on View Definitions by using desc
27) If view exists, drop view
28) MAKE_REF and user view
29) Modifying a View
30) ORA-01402
31) Perform select on columns in a view
32) Performing a SELECT on a View
33) Performing an INSERT Using a View
34) Query a filtering view
35) Query a view with condition
36) Query a view with subquery
37) The OR REPLACE clause is used to modify a view; basically, you are re-creating the view
38) Top N analysis
39) Update a view
40) Use ALTER VIEW to drop a constraint
41) Use view based on user-defind type
42) Use view to simplify the query
43) Use view to wrap complex select statement
44) User view and object id
45) Using view to simplify the query
46) Views